------
1. Instalacja biblioteki
------
pip install mysql-connector-python



------
2. Polaczenie z baza i select

import mysql.connector

conn = mysql.connector.connect(
    host="localhost",
    user="root",
    password="",
    database="your_database"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")

for row in cursor.fetchall():
    print(row)

conn.close()


------
3. Wykonywanie kilku kwerend
------

queries = [
    "INSERT INTO users(name) VALUES('Alice')",
    "INSERT INTO users(name) VALUES('Bob')",
    "UPDATE users SET active=1 WHERE name='Alice'",
]

for q in queries:
    cursor.execute(q)

conn.commit()



------
4. Przykład importu pliku CSV
------

import pandas as pd
import mysql.connector

# ------------------------
# CONNECT TO DATABASE
# ------------------------
conn = mysql.connector.connect(
    host="localhost",
    user="root",
    password="",
    database="mydb"
)
cur = conn.cursor()

# ------------------------
# LOAD CSV INTO MEMORY
# ------------------------
df = pd.read_csv("data.csv")

# ------------------------
# SPLIT INTO TABLE-SPECIFIC DATAFRAMES
# ------------------------
users_df = df[['user_id', 'name', 'email']].drop_duplicates()
orders_df = df[['order_id', 'user_id', 'product', 'total']]

# ------------------------
# INSERT INTO `users` TABLE
# ------------------------
cur.executemany("""
    INSERT INTO users (user_id, name, email)
    VALUES (%s, %s, %s)
""", users_df.values.tolist())

# ------------------------
# INSERT INTO `orders` TABLE
# ------------------------
cur.executemany("""
    INSERT INTO orders (order_id, user_id, product, total)
    VALUES (%s, %s, %s, %s)
""", orders_df.values.tolist())

conn.commit()
cur.close()
conn.close()

print("Import completed successfully!")